package tgc.edu.tms.repository;

import java.util.List;

import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;
import org.springframework.transaction.annotation.Transactional;

import tgc.edu.tms.custom.CommonRepository;
import tgc.edu.tms.entity.Jcb;
@Repository
public interface JcbRepository extends CommonRepository<Jcb, Integer> {

	public Jcb findByXqAndJcsj(String weekDay, String section);

	public List<Jcb> findByXq(String skxq);

	
	@Query(value="SELECT DISTINCT xq FROM jcb",nativeQuery=true)
	public List<String> findAllXq();

}
